#region Using directives
using System;
using System.Data;
using WP.Commons;
#endregion

namespace WP.MF.DataEntity
{

	/*
	 * Created by Web Smart Create Code Tool
	 * At 4/20/2005
	 */

	//=========MLocation  ============================
	[System.ComponentModel.DesignerCategory("Code")]
    public class MLocationDEL : DataSet, IDataEntity
	{
		//=========mLocation ============================
		public const string TABLENAME_MLOCATION="mLocation";
		public const string RECID="RecID";
		public const string LOCATIONNO="LocationNo";
		public const string LOCATIONDESC="LocationDesc";
		public const string BRANCHNO="BranchNo";
		public const string AVGWTAVG="AvgWtAvg";
		public const string DEFCREATEIMLOCATIONS="DefCreateImLocations";
		public const string TOTNOOFITEMS="TotNoOfItems";
		public const string MASTERBUYLOCATION="MasterBuyLocation";
		public const string CURNO="CurNo";
		public const string SURCHARGEPCT="SurchargePct";
		public const string DIRECTONLY="DirectOnly";
		public const string STREET="Street";
		public const string CITY="City";
		public const string PROVNO="ProvNo";
		public const string POSTALCODE="PostalCode";
		public const string FAX="Fax";
		public const string PHONE="Phone";
		public const string CONTACT="Contact";
		public const string PRTPRICE="PrtPrice";
		public const string PRTOETRAILRMK="PrtOeTrailRmk";
		public const string ACTIVE="Active";
		public const string REMANLOCATION="RemanLocation";
		public const string SLSCOMMPCT="SlsCommPct";
		public const string GAINPURCOMMPCT="GainPurCommPct";
		public const string LOSSPURCOMMPCT="LossPurCommPct";
		public const string GAINSLSCOMMPCT="GainSlsCommPct";
		public const string LOSSSLSCOMMPCT="LossSlsCommPct";
		public const string TRANSITLOCATION="TransitLocation";
		public const string SLSSHORTLOCATION="SlsShortLocation";
		public const string MILLSLSLOCATION="MillSlsLocation";
		public const string MILLSLSTRANFCUST="MillSlsTranfCust";
		public const string MILLSLSDESC="MillSlsDesc";
		public const string OWNBYSLSPNO="OwnBySlspNo";
        public const string SELLER = "Seller";
		public const string FREEDOCKDAYS="FreeDockDays";
		public const string BROKERSUPNO="BrokerSupNo";
		public const string WHARFAGERATEBYCRATE="WharfageRateByCrate";
		public const string LOCATIONZONE="LocationZone";
		public const string VMILOCATION="VmiLocation";
		public const string VMITYPE="VmiType";
		public const string VMIUSER="VmiUser";
		public const string VMICUSTNO="VmiCustNo";
		public const string REMANUSER="RemanUser";
		public const string OFFICEUSER="OfficeUser";
		public const string SALES01="Sales01";
		public const string SALES02="Sales02";
		public const string SALES03="Sales03";
		public const string SALES04="Sales04";
		public const string SALES05="Sales05";
		public const string COMMRATEPCT01="CommRatePct01";
		public const string COMMRATEPCT02="CommRatePct02";
		public const string COMMRATEPCT03="CommRatePct03";
		public const string COMMRATEPCT04="CommRatePct04";
		public const string COMMRATEPCT05="CommRatePct05";
		public const string COMPANYPHONE01="CompanyPhone01";
		public const string COMPANYPHONE02="CompanyPhone02";
		public const string BYEFFTWTAVGCOSTFORGM="ByEfftWtavgCostForGM";
		public const string COMMBASEDONQTY="CommBasedOnQty";
		public const string MINBFINSURESLSCOMMPCT="MinBFInsureSlsCommPct";
		public const string MINSFINSURESLSCOMMPCT="MinSFInsureSlsCommPct";
		public const string SLSCOMMPCTONLOWQTY="SlsCommPctOnLowQty";
		public const string AUTOFRTCOST="AutoFrtCost";
		public const string MINSALESINSURESLSCOMMPCT="MinSalesInsureSlsCommPct";
		public const string COMPANYNAME="CompanyName";
		public const string GOODSRECVSURPCT="GoodsRecvSurPct";
		public const string GOODSRECVSURACCTNO="GoodsRecvSurAcctNo";
		public const string GOODSRECVSURPROFITNO="GoodsRecvSurProfitNo";
		public const string GOODSRECVSURBRANCHNO="GoodsRecvSurBranchNo";
		public const string TAXCODE="TaxCode";
		public const string COMMACCTNO="CommAcctNo";
		public const string COMMPROFITNO="CommProfitNo";
		public const string COMMBRANCHNO="CommBranchNo";
		public const string TRANSFERLOCATION="TransferLocation";
		public const string NEEDUSEACTUALCOST="NeedUseActualCost";
		public const string ISINTERCOMPANY="IsInterCompany";
		public const string INTERCMPYDB="InterCmpyDB";
		public const string INTERCMPYDBPATH="InterCmpyDBPath";
		public const string INTERCMPYSUPNO="InterCmpySupNo";
		public const string INTERCMPYCUSTNO="InterCmpyCustNo";
        public const string INTERCMPYLOCNO = "InterCmpyLocNo";
		public const string DFTTOTSOSALES="DftToTSOSales";
		public const string PLACCTNO="PLAcctNo";
		public const string PLPROFITNO="PLProfitNo";
		public const string PLBRANCHNO="PLBranchNo";
		public const string EMAIL="Email";
		public const string MAINCASHIER="MainCashier";
		public const string PROFITNO="profitNo";
		public const string AVGCOSTGRPNO="AvgCostGrpNo";
		public const string AREANO="AreaNo";
		public const string PHYSICALLOC="PhysicalLoc";
		public const string DISCTYPE="DiscType";
		public const string NEEDSELECTCOST="NeedSelectCost";
		public const string ISSHARELOC="IsShareLoc";
		public const string COMMISSIONASDIRECTLOCATION="CommissionasDirectLocation";
		public const string TAGPREFIX="TagPrefix";
		public const string RECSTAMP="RecStamp";
        public const string USEMARKETCOSTINPO = "UseMarketCostInPo";
        public const string PAYTERMNO = "PayTermNo";
        public const string INTERCOMPANYACCTNO = "InterCompanyAcctno";
        public const string INTERCOMPANYPROFITNO = "InterCompanyProfitno";
        public const string INTERCOMPANYBRANCHNO = "InterCompanyBranchno";
        public const string COMMISSIONCOSTMARKUPPCT = "CommissionCostMarkUpPct";
        public const string NEEDADDFREIGHTCOST = "NeedAddFreightCost";

        public const string SERVICECHARGERATEPERMBF = "ServiceChargeRatePerMBF";
        public const string SERVICECHARGERATE = "ServiceChargeRate";
        public const string SERVICECHARGERATEUNIT = "ServiceChargeRateUnit";


        public const string PRINGCUSTOMVALUEONPULLCARD = "PringCustomValueOnPullCard";
        public const string PRINTITEMNOINOEFORM = "PrintItemNoInOeForm";
        public const string PRINTITEMNOINPOFORM = "PrintItemNoInPoForm";

        public const string ISTREATMENTLOCATION = "IsTreatmentLocation";

        public const string ARANNUALINTERESTRATE="ArAnnualInterestRate";
        public const string OVERDUEDAYSFORINTEREST="OverdueDaysForInterest";
        public const string APANNUALINTERESTRATE="ApAnnualInterestRate";
        public const string FREEDAYSFORINTEREST = "FreeDaysForInterest";
        public const string SERVICECHARGERATEPERMSF = "ServiceChargeRatePerMSF";

        public const string FRTPERTRUCK = "FrtPerTruck";
        public const string FRTPERRAIRCAR = "FrtPerRairCar";
        public const string FRTPERMBF = "FrtPerMBF";
        public const string FRTPERUNIT = "FrtPerUnit";
        public const string FRTPERMSF = "FrtPerMSF";
        public const string FRTSUPNO="FrtSupNo";
        public const string FRTTYPE="FrtType";
        public const string CUSTNO = "CustNo";
        public const string MINNONDISCAMTPERMBF = "MinNonDiscAmtPerMBF";
        public const String PRINTPALLET = "PrintPallet";
        public const String VmiShipToNo = "VmiShipToNo";
        public const string AVAILINCLUDEQUOTEQTY = "AvailIncludeQuotaQty";
        public const string STOREAREANO = "StoreAreaNo";
        public const string ISQUARANTINELOCATION = "IsQuarantineLocation";
        public const string QUARANTINELOCATIONNO = "QuarantineLocationNo";
        public const string ISTSO = "IsTSO";
        public const string NEXTOENO = "NextOeNo";
        public const string NEXTPONO = "NextPoNo";


      // FRTPERTRUCK,FRTPERRAIRCAR,FRTPERMBF,FRTPERUNIT
        //FrtPerTruck,FrtPerRairCar,FrtPerMBF,FrtPerUnit

        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }
         
		public MLocationDEL()
		{
			//Create mLocation structure
			CreatemLocationStructure();

		}

		//=========mLocation============================
        private void CreatemLocationStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_MLOCATION);
            DCC = table.Columns;

            DC = new DataColumn(FRTSUPNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(CUSTNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(FRTTYPE, typeof(System.String));
            DC.MaxLength = 10;
            DCC.Add(DC);

            DC = new DataColumn(MINNONDISCAMTPERMBF, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);
            
            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(LOCATIONNO, typeof(System.String));
            DC.MaxLength = SysVar.MaxLocLength;
            DCC.Add(DC);

            DC = new DataColumn(LOCATIONDESC, typeof(System.String));
            DC.MaxLength = 30;
            DCC.Add(DC);

            DC = new DataColumn(BRANCHNO, typeof(System.String));
            DC.DefaultValue = "000";
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(AVGWTAVG, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(DEFCREATEIMLOCATIONS, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(TOTNOOFITEMS, typeof(System.Int32));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(MASTERBUYLOCATION, typeof(System.String));
            DC.MaxLength = SysVar.MaxLocLength;
            DCC.Add(DC);

            DC = new DataColumn(CURNO, typeof(System.String));
            DC.MaxLength = 1;
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SURCHARGEPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(DIRECTONLY, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(STREET, typeof(System.String));
            DC.MaxLength = 60;
            DCC.Add(DC);

            DC = new DataColumn(CITY, typeof(System.String));
            DC.MaxLength = 30;
            DCC.Add(DC);

            DC = new DataColumn(PROVNO, typeof(System.String));
            DC.MaxLength = 5;
            DCC.Add(DC);

            DC = new DataColumn(POSTALCODE, typeof(System.String));
            DC.MaxLength = 10;
            DCC.Add(DC);

            DC = new DataColumn(FAX, typeof(System.String));
            DC.MaxLength = 25;
            DCC.Add(DC);

            DC = new DataColumn(PHONE, typeof(System.String));
            DC.MaxLength = 25;
            DCC.Add(DC);

            DC = new DataColumn(CONTACT, typeof(System.String));
            DC.MaxLength = 30;
            DCC.Add(DC);

            DC = new DataColumn(PRTPRICE, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(PRTOETRAILRMK, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);


            DC = new DataColumn(PRINTPALLET, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(ACTIVE, typeof(System.Boolean));
            //DC.DefaultValue="1";
            DCC.Add(DC);

            DC = new DataColumn(REMANLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(SLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(GAINPURCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(LOSSPURCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(GAINSLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(LOSSSLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(TRANSITLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(SLSSHORTLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(MILLSLSLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(MILLSLSTRANFCUST, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(MILLSLSDESC, typeof(System.String));
            DC.MaxLength = 60;
            DCC.Add(DC);

            DC = new DataColumn(OWNBYSLSPNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(SELLER, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(FREEDOCKDAYS, typeof(System.Int32));
            DC.DefaultValue = "1";
            DCC.Add(DC);

            DC = new DataColumn(BROKERSUPNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(WHARFAGERATEBYCRATE, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(LOCATIONZONE, typeof(System.String));
            DC.MaxLength = 4;
            DCC.Add(DC);

            DC = new DataColumn(VMILOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(VMITYPE, typeof(System.String));
            DC.DefaultValue = "S";
            DC.MaxLength = 1;
            DCC.Add(DC);

            DC = new DataColumn(VMIUSER, typeof(System.String));
            DC.MaxLength = 20;
            DCC.Add(DC);

            DC = new DataColumn(VMICUSTNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(REMANUSER, typeof(System.String));
            DC.MaxLength = 20;
            DCC.Add(DC);

            DC = new DataColumn(OFFICEUSER, typeof(System.String));
            DC.MaxLength = 20;
            DCC.Add(DC);

            DC = new DataColumn(SALES01, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SALES02, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SALES03, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SALES04, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SALES05, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMMRATEPCT01, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMMRATEPCT02, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMMRATEPCT03, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMMRATEPCT04, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMMRATEPCT05, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMPANYPHONE01, typeof(System.String));
            DC.MaxLength = 25;
            DCC.Add(DC);

            DC = new DataColumn(COMPANYPHONE02, typeof(System.String));
            DC.MaxLength = 25;
            DCC.Add(DC);

            DC = new DataColumn(BYEFFTWTAVGCOSTFORGM, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(COMMBASEDONQTY, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(MINBFINSURESLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(MINSFINSURESLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(SLSCOMMPCTONLOWQTY, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(AUTOFRTCOST, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(MINSALESINSURESLSCOMMPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(COMPANYNAME, typeof(System.String));
            DC.MaxLength = 40;
            DCC.Add(DC);

            DC = new DataColumn(GOODSRECVSURPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(GOODSRECVSURACCTNO, typeof(System.String));
            DC.MaxLength = 6;
            DCC.Add(DC);

            DC = new DataColumn(GOODSRECVSURPROFITNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(GOODSRECVSURBRANCHNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(TAXCODE, typeof(System.String));
            DC.MaxLength = 10;
            DCC.Add(DC);

            DC = new DataColumn(COMMACCTNO, typeof(System.String));
            DC.MaxLength = 6;
            DCC.Add(DC);

            DC = new DataColumn(COMMPROFITNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(COMMBRANCHNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(TRANSFERLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(NEEDUSEACTUALCOST, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(ISINTERCOMPANY, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(INTERCMPYDB, typeof(System.String));
            DC.MaxLength = 30;
            DCC.Add(DC);

            DC = new DataColumn(INTERCMPYDBPATH, typeof(System.String));
            DC.MaxLength = 200;
            DCC.Add(DC);

            DC = new DataColumn(INTERCMPYSUPNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(INTERCMPYCUSTNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(INTERCMPYLOCNO, typeof(System.String));
            DC.MaxLength = SysVar.MaxLocLength;
            DCC.Add(DC);

            DC = new DataColumn(DFTTOTSOSALES, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(PLACCTNO, typeof(System.String));
            DC.MaxLength = 8;
            DCC.Add(DC);

            DC = new DataColumn(PLPROFITNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(PLBRANCHNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(EMAIL, typeof(System.String));
            DC.MaxLength = 40;
            DCC.Add(DC);

            DC = new DataColumn(MAINCASHIER, typeof(System.String));
            DC.MaxLength = 20;
            DCC.Add(DC);

            DC = new DataColumn(PROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(AVGCOSTGRPNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(AREANO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(PHYSICALLOC, typeof(System.String));
            DC.MaxLength = 30;
            DCC.Add(DC);

            DC = new DataColumn(DISCTYPE, typeof(System.String));
            DC.MaxLength = 1;
            DCC.Add(DC);

            DC = new DataColumn(NEEDSELECTCOST, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(ISSHARELOC, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(COMMISSIONASDIRECTLOCATION, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(TAGPREFIX, typeof(System.String));
            DC.MaxLength = 1;
            DCC.Add(DC);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(USEMARKETCOSTINPO, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(PRINGCUSTOMVALUEONPULLCARD, typeof(System.Boolean));
            //DC.DefaultValue="0";
            DCC.Add(DC);

            DC = new DataColumn(PRINTITEMNOINOEFORM, typeof(System.Boolean));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(PRINTITEMNOINPOFORM, typeof(System.Boolean));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(PAYTERMNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPANYACCTNO, typeof(System.String));
            DC.MaxLength = 6;
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPANYPROFITNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPANYBRANCHNO, typeof(System.String));
            DC.MaxLength = 3;
            DCC.Add(DC);

            DC = new DataColumn(COMMISSIONCOSTMARKUPPCT, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);


            DC = new DataColumn(NEEDADDFREIGHTCOST, typeof(System.Boolean));
            DC.DefaultValue = true;
            DCC.Add(DC);


            DC = new DataColumn(SERVICECHARGERATEPERMBF, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(SERVICECHARGERATE, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(ARANNUALINTERESTRATE, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OVERDUEDAYSFORINTEREST, typeof(System.Int32));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(APANNUALINTERESTRATE, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FREEDAYSFORINTEREST, typeof(System.Int32));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(SERVICECHARGERATEUNIT, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(ISTREATMENTLOCATION, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(SERVICECHARGERATEPERMSF, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(FRTPERTRUCK, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FRTPERRAIRCAR, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FRTPERMBF, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FRTPERMSF, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(FRTPERUNIT, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(VmiShipToNo, typeof(System.String ));
            DCC.Add(DC);

            DC = new DataColumn(AVAILINCLUDEQUOTEQTY, typeof(System.Boolean));
            DCC.Add(DC);
            DC = new DataColumn(STOREAREANO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ISQUARANTINELOCATION, typeof(System.Boolean));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(QUARANTINELOCATIONNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ISTSO, typeof(System.Boolean));
            DC.DefaultValue = "0";
            DCC.Add(DC);


            DC = new DataColumn(NEXTPONO , typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(NEXTOENO , typeof(System.String));
            DCC.Add(DC);


            //FRTPERTRUCK,FRTPERRAIRCAR,FRTPERMBF,FRTPERUNIT
            this.Tables.Add(table);
        }

	}
}